package cn.tedu._04mybatis.mapper;

import cn.tedu._04mybatis.pojo.entity.Comment;
import cn.tedu._04mybatis.pojo.vo.CommentVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author tune_the last
 * @date 2025/11/8 - 11:24
 */
@Mapper
public interface CommentMapper {
    @Insert("INSERT INTO comment(content, created, user_id, weibo_id) VALUES (#{content}, #{created}, #{userId}, #{weiboId})")
    int insertComment(Comment comment);

    @Delete("DELETE FROM comment WHERE id = #{id}")
    int deleteById(Integer id);

    @Select("SELECT content, user_id userId, weibo_id weiboId FROM comment WHERE id = #{id} ")
    CommentVo selectCommentById1(Integer id);

    @Select("SELECT content, user_id userId, weibo_id weiboId FROM comment  WHERE weibo_id = #{wid}")
    List<CommentVo> selectCommentById2(Integer wid);

}
